Release 10.1A: OpenEdge Data Management:
SQL Reference

Data types

CREATE TABLE statements specify the data type for each column in the table they define. This section describes the data types SQL supports for table columns. All the data types can store null values. A null value indicates that the value is not known and is distinct from all non-null values.

This is the syntax for a data type:

Syntax

char_data_type | exact_numeric_data_type | approx_numeric_data_type | date_time_data_type | bit_string_data_type | vararray_data_type

Example 1 illustrates the use of data types in a CREATE TABLE statement:

Example 1: Data types in CREATE TABLE statement

CREATE TABLE CUSTOMERS (CUST_NUM INTEGER NOT NULL, COMPANY VARCHAR (20) NOT NULL, CUST_REP INTEGER, CREDIT_LIMIT INTEGER, PRIMARY KEY (CUST_NUM)) ;

The OpenEdge SQL data types are:

CHARACTER
EXACT NUMERIC
APPROXIMATE NUMERIC
DATE-TIME
BIT STRING
ARRAY

Each data type is described in the following sections.